UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'czNvC5Iz/BlUSBkcTQKGRO30J7yo6hsMj83r0rr/mSA='
WHERE
key_id = '478f7550e5d22d403b2449fdd8c19636d48932faf00a161d5ec902da7de7ec9e'
AND (
token = 'czNvC5Iz/BlUSBkcTQKGRO30J7yo6hsMj83r0rr/mSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)