UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XbTu5Lp40hAcFqKef1451jpjUDb0nM5KkwHwcBwzbOQ='
WHERE
key_id = '4c7cb47d9f15626be8ffcf1762354f93795243ec8a00f2f36f3a16ea6252277b'
AND (
token = 'XbTu5Lp40hAcFqKef1451jpjUDb0nM5KkwHwcBwzbOQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)