UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47y4ZWEYhkCwunulZeX5SLzAmQTnRtU8+yOfB5NgfBg='
WHERE
key_id = '07c1d0150e6f8dcd4081f16663f5c21027cbac2262c68559da7a0f4851f2352f'
AND (
token = '47y4ZWEYhkCwunulZeX5SLzAmQTnRtU8+yOfB5NgfBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)