UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2Rjq5G6YxcG49nGOxcX3lkT6wvzI0boF++2MZXVSsI='
WHERE
key_id = '9d18ca4688a1f98d07eb946e9b24f0928dd3888a0242beead71eae4c6427d7a7'
AND (
token = 'z2Rjq5G6YxcG49nGOxcX3lkT6wvzI0boF++2MZXVSsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)