UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Y1mRzYDIc9O70YiFZ7AX66cIKfLx3scUaAOW3VX8bk='
WHERE
key_id = 'dc2ef9a5408f512f8abb13626d381f711edf2f5b8428e31a244347b3f111a622'
AND (
token = '3Y1mRzYDIc9O70YiFZ7AX66cIKfLx3scUaAOW3VX8bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)