UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QahDGUPSoGpGXpCPjHQBg2MGNzSRab3iNTmVVZeSM88='
WHERE
key_id = '747ca697a8a1db9efba38699e08e971882de2992ced420711cdd64a34a7e0730'
AND (
token = 'QahDGUPSoGpGXpCPjHQBg2MGNzSRab3iNTmVVZeSM88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)