UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5m/GWn4yBGWXL2kibi2Ykl8eyCxUc12n9RV+X2evQPI='
WHERE
key_id = '0fc23ae950feebd8b3993c0d67ac1228440717af03a8ad1cefebf163333d8188'
AND (
token = '5m/GWn4yBGWXL2kibi2Ykl8eyCxUc12n9RV+X2evQPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)