UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/WYVwHDdG3HqC5eKnIk616xcSVZzOkaO/TDN/A2qDp4='
WHERE
key_id = '71b682ae373e831324e954d93fc56ad72245c35b76870864f2752e9fe1cd9127'
AND (
token = '/WYVwHDdG3HqC5eKnIk616xcSVZzOkaO/TDN/A2qDp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)