UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R3qBPdRBjZXUwjI9dhNTibCkdkF9TM0Bn+XVtt02qOc='
WHERE
key_id = '1c1b4ab603e7c97defd13761fa0071df7495d9d41709e461d090d68ab123583d'
AND (
token = 'R3qBPdRBjZXUwjI9dhNTibCkdkF9TM0Bn+XVtt02qOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)