UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pWY+mdO1nYnWQlA+FBuUJIyWhyANsq0P2EltKrDCQYI='
WHERE
key_id = 'd2e1328fb9f670c19eabca402e28034e3d5a2372d6374411c00b66cadfc596f1'
AND (
token = 'pWY+mdO1nYnWQlA+FBuUJIyWhyANsq0P2EltKrDCQYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)