UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'foIbauj5k2haSTn71Q2fobJjHh0jFIyzv//PkKIUewU='
WHERE
key_id = '10ef8e40c5f96209ab7fce17b752ba47a41cd259d2040c7a2366cb2fcaa5c924'
AND (
token = 'foIbauj5k2haSTn71Q2fobJjHh0jFIyzv//PkKIUewU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)