UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kAw3jnU0HBsvG/93rvtnT2LD9Km73lLehwsSk2pXwos='
WHERE
key_id = 'a4fc3f97fadb8211cafb1a5552f405812e43018ba001bbd8855f0e3042d3d95e'
AND (
token = 'kAw3jnU0HBsvG/93rvtnT2LD9Km73lLehwsSk2pXwos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)