UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RIPPyk4MC46UonoCYy5woXr44agmbpLhcBEZexp8BQQ='
WHERE
key_id = 'd9f9493385e03102fc9ed7ae0c344e8a32109b5dd8e8098b02851383ddfa6a1c'
AND (
token = 'RIPPyk4MC46UonoCYy5woXr44agmbpLhcBEZexp8BQQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)