UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVGDlbDSdqsiOMOV4aWIipQxOSsjoBGFm2v1Kr9lHkk='
WHERE
key_id = '353d1a67133aea77667c91526701eafb7186e65e54897a85cf9a92f4f458b009'
AND (
token = 'XVGDlbDSdqsiOMOV4aWIipQxOSsjoBGFm2v1Kr9lHkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)