UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sApoNLD5RK6HyOB72Gahycngiw/lPLV7E4wo9W075n4='
WHERE
key_id = 'e1817642c35b24cf3357d0acacd6a7ba03dbc90e3568d5c3a14cbed756c0166e'
AND (
token = 'sApoNLD5RK6HyOB72Gahycngiw/lPLV7E4wo9W075n4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)