UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Hof8hBfYA7JpWilLsrSXdhQT4+S/96bGLwFmLQ9Sic='
WHERE
key_id = '65379187e711fbff86ecd657ad564458e55f4bcb17aae4e3ab266daff07ee0e3'
AND (
token = '5Hof8hBfYA7JpWilLsrSXdhQT4+S/96bGLwFmLQ9Sic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)