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