UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4C8H5wiUur7/cqrVQoOdxJCNV37/ums1JBBjwmayHk='
WHERE
key_id = '7742e58f15269b631f82f78c0c001bb8b0836b1346b3bcef71e750afcea9b328'
AND (
token = 'a4C8H5wiUur7/cqrVQoOdxJCNV37/ums1JBBjwmayHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)