UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E7S2hEjVC1Dj8LDwvK17F2u9qMdiAsAcskb7q3SDcqs='
WHERE
key_id = '3f1d9b89d39522031bf7721bd84d855d4e98b2d3d8a2158aa409567a22920491'
AND (
token = 'E7S2hEjVC1Dj8LDwvK17F2u9qMdiAsAcskb7q3SDcqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)