UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXJoPlL3JCoe3pQaXYkWWv4hYKknaeX80t54hOJPfMs='
WHERE
key_id = '6630f86518f1916ea9a3a902276b7595f392e0104400ffcda78cfa7aa8dd8534'
AND (
token = 'BXJoPlL3JCoe3pQaXYkWWv4hYKknaeX80t54hOJPfMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)