UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ir7xekdLALOOsQ0Bn+K+k1f6PBmhkbDlA0mWlw1kH10='
WHERE
key_id = 'de9c45172968f58b9a2ab0da242cf67a0573a7f957fdbeb053c8fc25c5a1e6c7'
AND (
token = 'Ir7xekdLALOOsQ0Bn+K+k1f6PBmhkbDlA0mWlw1kH10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)