UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8SWMirFEWKG9OLxFWS/qTc82p3ochAeWzA4Mm+cxFCE='
WHERE
key_id = 'ce379818b635af6ecce0b7284421a74b88e332d8c38c749499075e49fbf77640'
AND (
token = '8SWMirFEWKG9OLxFWS/qTc82p3ochAeWzA4Mm+cxFCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)