UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8jQ+g32Xed98D/dfJp/l2fjab3dpvFe/p59eWHwYIg='
WHERE
key_id = '46d94719185473916886634319d9f3d915002dd109ab6b57675a0096ef08a352'
AND (
token = 'S8jQ+g32Xed98D/dfJp/l2fjab3dpvFe/p59eWHwYIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)