UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4VDy6XwCWULDTMWv0QS/W7dEQrwXr8zBN+oGqMr4X14='
WHERE
key_id = 'c54b2eae160936333bd6980b686c691143451d1dc3932add213c8873e383604e'
AND (
token = '4VDy6XwCWULDTMWv0QS/W7dEQrwXr8zBN+oGqMr4X14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)