UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DUa8oSusNKzwMuP8OMZE2WQqmHiSGCIO/bPewv1dZfU='
WHERE
key_id = '175672626b9d7ccd81e4ac46fdfbb88c39336daafcd471cfce824901d5b9504f'
AND (
token = 'DUa8oSusNKzwMuP8OMZE2WQqmHiSGCIO/bPewv1dZfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)