UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SGQCJuQbF3XIhkj9P9XviG9xoHKaZnezJm+PGhx/t+M='
WHERE
key_id = '2d77505c9ea78d93b9ba0a9a680931f9b9d2889eafb2c13900d677406f2eab1f'
AND (
token = 'SGQCJuQbF3XIhkj9P9XviG9xoHKaZnezJm+PGhx/t+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)